Hệ thống quản lý trường học bằng PHP / MySQLi
1 <?php
2 error_reporting(0);
3 $conn=mysqli_connect('localhost','root','','sms2')or die(mysqli_error("Connection error"));
4 ?>
5 <?php
6 require_once('session1.php');
7 ?>
8 <?php
9 $id = $_GET['id'];
10 $select = "SELECT * FROM
11 inventory WHERE asset_id=$id";
12 $result = mysqli_fetch_array(mysqli_query($select));
13 $qry=mysqli_query($select);
14 if($qry)
15 {
16 while($rec = mysqli_fetch_array($qry)){
17 $asset_code = "$rec[asset_code]";
18 $date_purchased = "$rec[date_purchased]";
19 $estimated_value = "$rec[estimated_value]";
20 $location = "$rec[location]";
21 $mode_make = "$rec[mode_make]";
22 $purchase_price = "$rec[purchase_price]";
23 $serial_number = "$rec[serial_number]";
24 $asset_condition = "$rec[asset_condition]";
25 $quantity = "$rec[quantity]";
26 $order_number = "$rec[order_number]";
27 $active = "$rec[active]";
28 $updated_by = "$rec[updated_by]";
29
30 }}
31 ?>
32 <?php
33 SESSION_START();
34 ?>
35
36 <!DOCTYPE html>
37 <html>
38
39 <head>
40 <meta charset="utf-8">
41 <meta name="viewport" content="width=device-width, initial-scale=1.0">
42 <title>school management system</title>
43 <link rel="shortcut icon" href="assets/img/title.gif" type="image/x-icon">
44 <link rel="stylesheet" href="assets/css/bootstrap.min.css">
45 <link href="assets/css/loader.css" rel="stylesheet" />
46 <script src="assets/js/canvasjs.min.js"></script>
47 <!--*****jquery -3.2.1.js file supports the use of dropdown***-->
48 <script src="assets/js/jquery-3.2.1.js"></script>
49 </head>
50
51 <body >
52 <!--end of heading section-->
53 <ul class="nav navbar-right top-nav">
54 <div class="dropdown">
55 <button class="btn btn-primary dropdown-toggle" type="button" data-toggle="dropdown" >
56 <?php
57 //Check to see if the user is logged in.if not redirect user to the loging page.
58
59 if(isset($_SESSION['fname']))
60 {
61 echo "Current user: ".$_SESSION['fname']. " ".$_SESSION['lname']. " ";
62 $currentuser=$_SESSION['fname']. " ".$_SESSION['lname'];
63 }else{
64 echo "<script type='text/javascript'>
65 alert( 'You must Log in to use the system');
66 </script>";
67 echo "<script>
68 window.location = 'index.php'
69 </script>";
70 }
71 ?>
72 <span class="caret"></span></button>
73 <ul class="dropdown-menu">
74 <li><a href="manage_account.php"><i class="fa fa-users fa-lg"></i> View User</a></li>
75 <li><a href="register_form.php"><i class="fa fa-users fa-lg"></i> Add New User</a></li>
76 <li class="divider"></li>
77 <li><a href="session_logout.php"><i class="fa fa-fw fa-power-off"></i> Log Out</a></li>
78 </ul>
79 </div>
80 </ul>
81 <!--************************************************-->
82 <div style="
83 font-family:Nyala, Arial;
84 text-align: left;
85 background-color: #526F35;
86 padding: 20px;
87 color:white;
88 width: 100%;
89 height: 150px;">
90 <!--This codes to load the image loader-->
91 <div id="loading">
92 <img id="loading-image" src="assets/img/loader.gif" alt="Loading..." />
93 </div>
94 <!--this is the heading section-->
95 <h2>
96 <?php
97 $query=mysqli_query("select * from companyinfo");
98 $num_rows=mysqli_num_rows($query);
99 while($row=mysqli_fetch_array($query))
100 {
101 echo '<image style="height:82px; width:82px;" src="data:image;base64,'. $row['clogo'].' "> ';
102 $cname = $row['cname'];
103 $cemail = $row['cemail'];
104 $ccontact = $row['ccontact'];
105 $clocation = $row['clocation'];
106 }?>
107 <?php
108 echo $cname;
109 ?>
110
111 <div style="float:right; font-size:20px;text-align:right;">
112
113 <img src="assets/img/mail2.png">Email: <?php echo $cemail; ?><br>
114 <img src="assets/img/call1.png">Contact:<?php echo $ccontact; ?><br>
115 <img src="assets/img/location.png">Location: <?php echo $clocation; ?>
116
117 </div>
118 </h2>
119 </div>
120 <!--end of heading section-->
121
122 <div>
123 <ul class="nav nav-tabs">
124 <li ><a href="homepage.php" >Administration <img src="assets/img/details.png"></a></li>
125 <li ><a href="students.php" >Students <img src="assets/img/student48.png"></a></li>
126 <li ><a href="staff.php">Staff Member <img src="assets/img/staff48.png"></a></li>
127 <li ><a href="course.php" >Courses <img src="assets/img/course.png"></a></li>
128 <li ><a href="departments.php" >Departments <img src="assets/img/department.png"></a></li>
129 <li><a href="markstep1.php" >Exams <img src="assets/img/update.png"></a></li>
130 <li><a href="hostel.php" >Hostel <img src="assets/img/details.png"></a></li>
131 <li><a href="sms.php">SMS <img src="assets/img/details.png"></a></li>
132 <!--<li><a href="tab-8" role="tab" data-toggle="tab">Hostel <img src="assets/img/details.png"></a></li>
133 <li><a href="tab-7" role="tab" data-toggle="tab">Parents <img src="assets/img/details.png"></a></li>-->
134
135 </ul>
136 <div class="tab-content">
137 <div class="tab-pane active" role="tabpanel" id="tab-1">
138
139 <p>
140 <div class="table-responsive" >
141 <!--****************************************************************************-->
142 <div class="container" style="width:100%">
143
144 <ul class="nav nav-tabs">
145 <li ><a href="#">New Asset<img src="assets/img/new.png"> </a></li>
146 <li ><a href="view_inventory.php">View List<img src="assets/img/view2.png"> </a></li>
147 <li class="active"><a href="edit_inventory.php">Edit<img src="assets/img/edit2.png"> </a></li>
148 <li ><a href="dispose_inventory.php">Dispose/ Write off<img src="assets/img/dispose.png"> </a></li>
149 <li ><a href="reports_inventory.php">Reports<img src="assets/img/report2.png"> </a></li>
150 </ul>
151 <br>
152
153 </div>
154
155 <!--*************************************************************************************************************************-->
156 <div class="container-fluid">
157 <div class="row">
158 <div class="col-lg-6 col-lg-offset-3">
159 <div class="panel panel-primary">
160 <div class="panel-heading">Add new Asset</div>
161
162 <!-- /.panel-heading -->
163 <div class="panel-body">
164 <div class="table">
165 <form action="update_inventory.php" method="POST" enctype="multipart/form-data">
166
167 <label>Asset code [<font color="red">*</font>]</label>
168 <input type="text" name="asset_code" class="form-control" readonly value="<?php echo $asset_code?>">
169 <label>Date Purchased [<font color="red">*</font>]</label>
170 <input type="DATE" name="date_purchased" class="form-control" value="<?php echo $date_purchased?>">
171 <label>Estimated_value</label>
172 <input type="number" name="estimated_value" value="<?php echo $estimated_value?>" class="form-control">
173 <label>location</label>
174 <input type="text" name="location" class="form-control" value="<?php echo $location?>">
175 <label>model_make</label>
176 <input type="text" name="mode_make" class="form-control" value="<?php echo $mode_make?>">
177 <label>purchase_price</label>
178 <input type="number" name="purchase_price" class="form-control" value="<?php echo $purchase_price?>">
179
180 <label>serial_number</label>
181 <input type="text" name="serial_number" class="form-control" value="<?php echo $serial_number?>">
182 <label>condition</label>
183 <input type="text" name="asset_condition" class="form-control" value="<?php echo $asset_condition?>">
184 <label>quantity</label>
185 <input type="number" name="quantity" class="form-control" value="<?php echo $quantity?>">
186 <label>order_number</label>
187 <input type="number" name="order_number" class="form-control" value="<?php echo $order_number?>">
188 <input type="hidden" name="active" class="form-control" value="<?php echo $active?>">
189 <input type="hidden" name="reason_for_disposing" class="form-control" value="">
190 <label>updated_by</label>
191 <input type="text" name="updated_by" readonly class="form-control" value="<?php echo $currentuser?>"><br>
192
193 <input type="submit" name="register" value="Update" class="btn btn-success" ><br><br>
194
195 </form>
196 <!--****************************************************************************-->
197
198
199 <!--*******************************try add parent's details******************************************************-->
200
201
202
203 </div>
204 </div>
205 </div>
206 <!-- /.container-fluid -->
207 </div>
208 <!-- /#page-wrapper -->
209 </div>
210 </div>
211
212
213
214
215 <div div class="col-md-12" style="background-color:#526F35;bottom:0px; position:fixed;">
216 <p class="text-center text-danger" style="color:white;">@J. Muthama Tel: +254729734768</p>
217 </div>
218 <script src="assets/js/jquery.min.js"></script>
219 <script src="assets/bootstrap/js/bootstrap.min.js"></script>
220 <script src="assets/js/affix.js"></script>
221 <script src="assets/js/alert.js"></script>
222 <script src="assets/js/alert1.js"></script>
223 <script src="assets/js/bootstrap.js"></script>
224 <script src="assets/js/bootstrap.min.js"></script>
225 <script src="assets/js/bootstrap-datepicker.js"></script>
226 <script src="assets/js/bootstrap-wysihtml5.js"></script>
227 <script src="assets/js/button.js"></script>
228 <script src="assets/js/carousel.js"></script>
229 <script src="assets/js/chosen.jquery.min.js"></script>
230 <script src="assets/js/ckeditor.js"></script>
231 <script src="assets/js/collapse.js"></script>
232 <script src="assets/js/color.js"></script>
233 <script src="assets/js/dropdown.js"></script>
234 <script src="assets/js/DT_bootstrap.js"></script>
235 <script src="assets/js/dynamic.js"></script>
236 <script src="assets/js/ie-emulation-modes-warning.js"></script>
237 <script src="assets/js/jquery.dataTables.js"></script>
238 <script src="assets/js/jquery.dataTables.min.js"></script>
239 <script src="assets/js/jquery.dialog.js"></script>
240 <script src="assets/js/jquery.hoverdir.js"></script>
241 <script src="assets/js/jquery.jgrowl.js"></script>
242 <script src="assets/js/jquery.knob.js"></script>
243 <script src="assets/js/jquery.uniform.min.js"></script>
244 <script src="assets/js/jquery-1.8.3.min.js"></script>
245 <script src="assets/js/jquery-1.9.1.js"></script>
246 <script src="assets/js/jquery-1.9.1.min.js"></script>
247 <script src="assets/js/jquery-1.10.2.js"></script>
248 <script src="assets/js/jquery-1.11.0.js"></script>
249 <script src="assets/js/jquery-ui-1.9.2.custom.min.js"></script>
250 <script src="assets/js/jquery-ui-1.10.3.js"></script>
251 <script src="assets/js/modal.js"></script>
252 <script src="assets/js/modernizr-2.6.2-respond-1.1.0.min.js"></script>
253 <script src="assets/js/myjquery.js"></script>
254 <script src="assets/js/myjquery1.js"></script>
255 <script src="assets/js/npm.js"></script>
256 <script src="assets/js/popover.js"></script>
257 <script src="assets/js/profile.js"></script>
258 <script src="assets/js/raphael-min.js"></script>
259 <script src="assets/js/sb-admin-2.js"></script>
260 <script src="assets/js/scripts.js"></script>
261 <script src="assets/js/scrollspy.js"></script>
262 <script src="assets/js/tab.js"></script>
263 <script src="assets/js/tooltip.js"></script>
264 <script src="assets/js/transition.js"></script>
265 <script src="assets/js/wysihtml5-0.3.0.js"></script>
266 <script language="javascript" type="text/javascript">
267 $(window).load(function()
268 {
269 $('#loading').hide();
270 });
271 </script>
272 </body>
273
274 </html>